KS_CONTACTS

1

Contact Number

string

30

Y

Must be unique

2

Kommerce
Server ID

integer

4

This is the KommerceServer reference number for this contact It is only needed when the contact was originally created in KS as a cross reference to the contact number assigned by the ERP system when imported.

3

Display Name

string

100

Y

This is the name that displays on the web and listing pages

4

Position

string

100

5

Phone

string

25

No need to resend related customer phone number (only if direct line to contact).

6

Email Address

string

100

7

First Name

string

30

8

Last Name

string

30

9

Middle Name

string

30

10

Name Prefix

string

10

11

Name Suffix

string

10

12

Company Number

string

30

Y

This is actually the xref_id which is looked up in the foreign key table to find the actual pk value (integer) in SQL DB. The lookup is a combination of type and company number.

13

Business Type

string

1

Y

'C'=Customer
'E'=End User

Used to lookup the type of company the contact is associated. See comment above.

14

Contact Class

string

30

A lookup is performed using this value against the classification.class_xref_id. See KS_CLASSIFICATIONS export

15

Department

string

30

A lookup is performed using this value against the business_unit.unit_xref_id column. This field is used by the webTeam application

16

Fax Number

string

25

17

Mobile Number

string

25

18

Address Number

string

30

A lookup is performed using the value against the entity_address.address_xref_id column. The value should correspond to the addresses sent in the KS_SHIP_ADDRS export. If this is blank the assumption is the contact is associated with the primary address for the company sent in KS_CUSTOMERS or KS_ENDUSERS export.

19

Active Flag

string

1

Y

"Y"= Active
"N"=Inactive

If set to "N" this contact will still show for historical transactions but will not be selectable for any new transactions. The Auto Set Web Access Code would likely be set to "REMOVE" in this case as well.

20

Auto Set Web Access Code

string

10

"ACTIVATE" "DEACTIVATE"_ "REMOVE"

If set to "ACTIVATE" a web account will be created and a password generated only if a Web Account does not exist. If a Web Account already exists, this code will ensure that the account is active only. If Set to "DEACTIVATE" and a Web Account exists, the password will be preserved but the web access will be denied. If set to "REMOVE" the Web Account will be removed entirely if it exists. If a Web Account does not exist, no change occurs for "DEACTIVATE" or "REMOVE". Note: This feature can conflict with interactive changes that may be allowed on-line. If web access is to be maintained on-line exclusively then this field should be left blank.